package org.jeecg.modules.zcgl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.zcgl.entity.StatementAccountDetails;

import java.util.List;

/**
 * @Description: 对账单详情
 * @Author: jeecg-boot
 * @Date:   2021-01-15
 * @Version: V1.0
 */
public interface StatementAccountDetailsMapper extends BaseMapper<StatementAccountDetails> {

	public boolean deleteByMainId(@Param("mainId") String mainId);
    
	public List<StatementAccountDetails> selectByMainId(@Param("mainId") String mainId);

	@Select("select * from zcgl_statement_account_details where statement_account_id = #{statementAccountId} and transaction_id = #{transactionId} and del_flag = 0")
    StatementAccountDetails selectByStatementAccountIdAndTransactionId(String statementAccountId, String transactionId);
}
